<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic xml:lang="en" id="topic1">
  <title>pg_extension</title>
  <body>
    <p>The system catalog table <codeph>pg_extension</codeph> stores information about installed
      extensions.</p>
    <table id="table_zgy_xfx_tz">
      <title>pg_catalog.pg_extension</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="131pt"/>
        <colspec colnum="2" colname="col2" colwidth="86pt"/>
        <colspec colnum="3" colname="col3" colwidth="85pt"/>
        <colspec colnum="4" colname="col4" colwidth="147pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1"><codeph>extname</codeph></entry>
            <entry colname="col2">name</entry>
            <entry colname="col3"/>
            <entry colname="col4">Name of the extension.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>extowner</codeph></entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3">pg_authid.oid</entry>
            <entry colname="col4">Owner of the extension</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>extnamespace</codeph></entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3">pg_namespace.oid</entry>
            <entry colname="col4">Schema containing the extension exported objects.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>extrelocatable</codeph></entry>
            <entry colname="col2">boolean</entry>
            <entry colname="col3"/>
            <entry colname="col4">True if the extension can be relocated to another schema.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>extversion</codeph></entry>
            <entry colname="col2">text</entry>
            <entry colname="col3"/>
            <entry colname="col4">Version name for the extension.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>extconfig</codeph></entry>
            <entry colname="col2">oid[]</entry>
            <entry colname="col3">pg_class.oid</entry>
            <entry colname="col4">Array of <codeph>regclass</codeph> OIDs for the extension
              configuration tables, or <codeph>NULL</codeph> if none.</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>extcondition</codeph></entry>
            <entry colname="col2">text[]</entry>
            <entry colname="col3"/>
            <entry colname="col4">Array of <codeph>WHERE</codeph>-clause filter conditions for the
              extension configuration tables, or <codeph>NULL</codeph> if none.</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
    <p>Unlike most catalogs with a namespace column, <codeph>extnamespace</codeph> does not imply
      that the extension belongs to that schema. Extension names are never schema-qualified. The
        <codeph>extnamespace</codeph> schema indicates the schema that contains most or all of the
      extension objects. If <codeph>extrelocatable</codeph> is <codeph>true</codeph>, then this
      schema must contain all schema-qualifiable objects that belong to the extension.</p>
  </body>
</topic>
